SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_CheckEmployerNameIsExist]
    (
      @JOL_Employer_Account VARCHAR(50)--这里其实参数命名错误了，用这个名字只是为了在后台中重用一个函数
    )
AS 
    SELECT  COUNT(JOL_Employer_Name)
    FROM    dbo.JOL_Employer
    WHERE   JOL_Employer_Name = @JOL_Employer_Account
GO
